OperatorTaxHistory

Entity Definition

Logical Name : OperatorTaxHistory
Physical Name : LE_HST_OPR_TX

A collection of tax totals for a tax authority by operator for a reporting period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxRateRule(RU_TX_RT)
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer OperatorHistory(LE_HST_OPR)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer OperatorHistory(LE_HST_OPR)
TaxRateRuleSequenceNumber (FK)(PK) A squential number for theTaxRateRule, denoting the order of creation of the rules. AI_TX_RT_RU LineNumber smallint TaxRateRule(RU_TX_RT)
TaxCollectedTotalAmount The total monetary amount of tax recorded by OPERATOR for each REPORTING PERIOD. CP_TX_CLT_TOT Money decimal(16,5)
TaxableSaleTotalAmount The total monetary amount of taxable sales recorded by OPERATOR for each REPORTING PERIOD. CP_SLS_TX_TOT Money decimal(16,5)
TaxExemptSaleTotalAmount The total monetary amount of tax exempt sales recorded by OPERATOR for each REPORTING PERIOD. CP_SLS_TX_EXM_TOT Money decimal(16,5)
TaxExemptTransactionCount The total number of tax exempt sales recorded by OPERATOR for each REPORTING PERIOD. QU_TRN_TX_EXM_TOT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
TaxRateRule is summarized in OperatorTaxHistory
OperatorHistory may include OperatorTaxHistory

Logical Views containing OperatorTaxHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03120 - Reporting - Store Operations - Period View
Logical 05000 - Taxation - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 11160 - Worker - Reporting View